home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
DEMOCIAL
/
DEMOFRM1.LZH
/
FRAMEWRK.DOC
< prev
next >
Wrap
Text File
|
1986-08-13
|
55KB
|
1,304 lines
ASHTON-TATE
FRAMEWORK II SAMPLER
-----------------------------------------------------------------------
Introduction
If you've decided it's time to take advantage of what a personal com-
puter can do for you, then it's time to consider using Framework II.
Framework II, by Ashton-Tate, combines the most needed productivity
applications - word processing, spreadsheet, and more - into one
consistent and powerful software program.
The Framework II Sampler requires an IBM PC, PC/XT, AT or 100% compat-
ible, at least 384K of internal memory (RAM), one 360K floppy-disk
drive, and a monochrome or graphics monitor.
The Framework II Sampler includes two disks that contain a sample of
the actual Framework II software. The Sampler program does not include
all the capabilities of Framework II - for example, you cannot save
work to a disk or print it out on paper. But it does provide you the
opportunity to get hands-on experience with the Framework II software,
so you can try it before you buy it.
The Sampler program includes an automated demonstration that runs about
14 minutes. Step-by-step instructions for a hands-on experience with
Framework II are also included in this documentation. Five simple
exercises cover a few of the basic features of Framework II and take
about 5 to 10 minutes each to complete. So, within a half hour to 45
minutes, you can get a pretty good idea of some of the capabilities
Framework II offers in word processing, spreadsheets, and more.
The Framework II Sampler package will let you know exactly what
Framework II can do, so you can decide whether or not Framework II is
for you.
After you've made your decision, do a friend a favor - pass along your
Framework II Sampler.
About Framework II
What is Framework II?
Framework II is the single software program that combines word
processing and spreadsheets with one consistent set of common commands,
and provides enough power to enable you to get the most out of your
computer as your needs and capabilities grow.
Framework II is more than just a word processor.
It is a sophisticated yet easy-to-use tool for:
quickly organizing thoughts before turning them into text
creating and editing a variety of documents, including form letters
capturing and reusing frequently used terms and information
automatically checking and correcting spelling
And the word processor in Framework II works hand-in-hand with the
spreadsheet in Framework II.
Framework II easily combines and exchanges information among different
applications.
You can combine word processing, spreadsheets, and graphics within a
single file - even print out reports with words, numbers, and graphics
on a single page.
Framework II works with outside sources of information too.
Built-in telecommunications enables you to electronically communicate
words and numbers to and from other computers, large and small, over
ordinary telephone lines. And the ability of Framework II to work with
information from other leading software programs makes it the perfect
fit in almost any microcomputer environment.
Framework II combines the following functions into one consistent pro-
gram:
Word Processing <--------------------> Spreadsheet
/\ /\ /\ /\ /\ /\
| | | |---------------------------| |
| | Mail Merge | | Graphing
| Outlining /\ | |
Spell Check |----Database Telecommunications
Who needs Framework II?
Framework II is designed for people who create, analyze, or organize
information. And for people who don't have a lot of time to spend
learning a difficult software package. This includes most managers and
professionals, and those administrative and support personnel who
frequently work with words and numbers.
For novice and experienced users alike
New Framework II users become productive fast. Concepts are quickly
organized and developed into finished documents, complete with words,
numbers, and graphs. After gaining more experience, users can take
advantage of the more powerful features of Framework II.
The "pull-down" menu system in Framework, the plain English commands,
and the easy-to-manage "desktop environment" have been praised by
industry experts and users alike. The common command structure enables
users to learn the basics of one application and, as a result, know the
basics of all the others.
Framework II is designed For tasks such as...
for people in...
Marketing Business Planning
Sales Budget Keeping and Analysis
Finance Customer Tracking
Personnel Contract Preparation
Consulting Portfolio Analysis
Strategic Planning Project Planning
Corporate Analysis Brainstorming
Investment Management Department Management
General Business Research Proposals and Reports
Venture Capital Loan Analysis
Entrepreneurial Ventures Financial Planning
Real Estate Report Writing
Banking Cost/Benefit Analysis
Insurance Book Writing
Law Form Letter Generation
Medicine Medical Reports
Higher Education Scientific Analysis
Who doesn't need Framework II?
Framework II is not designed for confirmed "one-track" computer users -
or people who are sure that only a word processing program or only a
spreadsheet program is all that they will ever need. Many people start
using a computer with one primary application in mind, but they soon
discover that there are other computer capabilities that will help make
them more effective and productive - a key reason to choose Framework
II.
Framework II is NOT designed for people who...
do not create, analyze, or organize information
will always use their computer for only one application
require data capacities outside the scope of Framework II
While some Framework users concentrate on the word processing, and
others on the spreadsheet, Framework II has been designed to handle both
kinds of work optimally.
So even if your work is almost entirely word processing, or
manipulating spreadsheets, and only need the other Framework II
capabilities occasionally, Framework II will save you time. Because of
the common user interface and consistent commands within Framework II,
you can take advantage of seldom-used applications without having to
re-learn them every time you use them.
If you have a question about Framework II and your particular needs,
check the Framework II capacities and specifications at the end of this
document, or check with your authorized Ashton-Tate dealer for details.
If you require extremely large databases, you may want to first
consider dBASE III PLUS, the best selling database for microcomputers
on the market, also by Ashton-Tate. Framework II users can access data
from dBASE II and dBASE III files - to analyze and graph information or
produce form letters, for example. But dBASE is designed to handle
thousands and thousands of records of information, while Framework II
is designed to handle hundreds of records comfortably, although it can
accommodate several thousand.
Five good reasons to use Framework II
1. Framework II provides faster problem solving and productivity than
separate programs or other multi-function products.
Once you learn the basics, you can immediately begin to produce
useful work. And what you learn in one application transfers to
others. You can move from task to task as quickly as situations
change in your day-to-day business. Compare the user interface and
command structure of Framework II to other multi-function products
and see the difference for yourself.
2. Framework II grows with your needs and capabilities as you gain
experience.
With FRED, the programming language included with Framework II, you
can create your own applications. Or take advantage of FRED appli-
cations developed by others, for example, TimeFrame, a calendar and
office assistant program, and FrameLock, a data encryption program
for file security.
And when you're ready for telecommunications, all you have to do is
purchase a modem to connect to your phone line. The software
necessary to use it is already built into Framework II, so there is
no new software program to learn from scratch.
3. Framework II costs less than separate programs offering comparable
capabilities.
Cost less both in terms of direct purchase costs, and the indirect
costs involved with learning the different command structures of
different programs. The more time you spend learning separate pro-
ducts, the less time you spend doing.
4. Framework II preserves your investment in other software because it
can work with files from other software programs.
Framework II has new "Import" and "Export" commands for using files
from other programs, enabling you to work with information from
programs such as dBASE II and dBASE III, MultiMate, 1-2-3,
Displaywrite, WordStar, and VisiCalc.
5. Framework II is produced and supported by Ashton-Tate, one of the
leading producers of computer software worldwide.
When you're thinking about software, you need to think not only
about what it does, but where it comes from. In a business where
many come and go, Ashton-Tate remains a solid investment, offering
quality support, continued product improvements, books, and transla-
tions.
But then, don't take our word for it. Just listen to what the experts
said about the original Framework products.
What the experts say about Framework
Most Significant Product of 1984
PC WEEK, the weekly guidebook for many corporate PC managers, acknowledged Framework's value to PC users with a PC WEEK Award for Most
Significant Product.
Product of the Year
In France, where Framework was named 1984 Product of the Year, Frame-
work continues to be the best-selling multi-function software program
in the country, far outselling even 1-2-3 by Lotus.
Award for Technical Excellence
PC Magazine recognized Framework's creator for the product's techni-
cal elegance, functional power, and consistent simplicity.
#1 in an Independent Software Evaluation
Software Digest, the "Consumer Reports" of the software industry, put
Framework at the top of the list in its overall evaluation of more
than a dozen multi-function products.
"...a magnificent tool..."
The Research in Word Processing Newsletter reports:
"Even those writers who may never use Framework's spreadsheet, data-
base management, telecommunications, or graphics modules should have
a look at the program. It is, simply put, a magnificent tool for
writing."
"Spreadsheet Software Face-Off" Champion
As reported in the New York Times ..."The contestants in the Spread-
sheet Software Face-Off, which was sponsored by PC Magazine and the
Wharton School of Finance in Philadelphia, were the defending champ-
ion 1-2-3 and its Lotus stablemate, Symphony; the venerable VisiCalc;
SuperCalc3; Framework; Enable; Smart; Multiplan; PeachCalc, and
pfs:Plan....When the smoke cleared at high noon on Sunday, there was
a new champion in town: Framework..."
"Framework Beats the Band
-Versus Symphony, better integration and ease of use"
This was the headline in InfoWorld Magazine, In an issue comparing
Lotus's Symphony and Ashton-Tate's Framework, Framework emerged the
clear favorite.
Why Framework II?
The best reviewed multi-function software has just been improved. Why?
Ashton-Tate gratefully acknowledges the praise given the original
Framework program, but Ashton-Tate also listens to suggestions from
Framework users. Ashton-Tate has made Framework II an easier, faster,
and more powerful program for those people who need both word pro-
cessing and spreadsheet capabilities.
Framework II, by Ashton-Tate
Here are some of the improvements included in Framework II as an
outgrowth of an ongoing dialogue with Framework users:
The ability to work with larger files, and more files at once
Ability to extend beyond 640K RAM limit, with extra RAM or a hard
disk
Larger spreadsheets, up to 32,000 rows and 32,000 columns
Faster spreadsheet recalculation
Goto command for spreadsheet navigation
Spreadsheet range printing
High-Low-Close Graphs
Built-in macro and abbreviation capabilities
Visible page breaks
A spelling checker
Print formatting controls within pull-down menus
Built-in mail-merge and label printing
Completely integrated telecommunications
Terminal emulation
Built-in file import and export capabilities
New Applications menu, with add-in slots for custom programs
For the power user, additional FRED language capabilities
New setup program for customizing Framework II to your PC
More in-depth on-disk tutorial
New set of manuals
Getting Down to Business
You can sample Framework II in the way you find most comfortable:
If "seeing" is believing, then just watch the automated demonstr-
ation.
If "keying" is believing, try the hands-on exercises.
The examples covered in the Sampler demonstration and exercises are
purposely kept simple so you can get a quick idea of some of the
capabilities Framework II offers. Of course, Framework II handles much
larger and more complex problems than what's covered here.
The Framework II Sampler requires an IBM PC,XT,AT, or 100% compatible,
at least 384K of internal memory (RAM), one 360K floppy-disk drive, and
a monochrome or graphics monitor.
And remember, the Framework II Sampler is not the actual Framework II
program.
Files cannot be saved to disk or printed.
Memory beyond 640K cannot be accessed.
Files from other programs cannot be used. Exception: files from
dBASE II and dBASE III, and ASCII Text files.
Telecommunication capabilities are not present.
Except for a few example Help screens, the on-line Help system is
not present.
The Spelling Checker dictionary contains only a few thousand words,
as opposed to the 80,000 word dictionary included with the real
Framework II.
MailMerge and label printing are disabled.
How to Start the Framework II Sampler Program
If you have a hard disk, you can run the Framework II Sampler either
from the floppy-disk (the "A" drive), or from the hard disk itself (the
"C" drive). Just follow the appropriate instructions below.
Floppy-Disk Drive
To run the Framework II Sampler from a floppy-disk drive:
In Order to: Do This:
1. Load DOS into your computer Insert DOS disk (version 2.0 or
higher) into drive "A"
Turn on computer
2. Leave date and time unchanged Press [ENTER] twice
and bring up the "A" prompt
Note: If you are using the floppy-disk drive on a hard-disk system,
insert Sampler Disk 1 into drive "A" and then type a: and press [ENTER]
to bring up the "A>" prompt.
3. Start Framework II Sampler Insert Sampler Disk 1 into drive
"A", type FWSAMPLE, and press
[ENTER]
When prompted, insert Sample
Disk 2 into drive "A" and press
[ENTER]
After some disk whirring, the Framework II Sampler Menu appears on the
screen. Skip ahead to the The Sampler Menu section.
Hard-Disk Drive
To prepare the Framework II Sampler for running from a hard-disk drive,
you need to first copy the files from the two Sampler Disks onto a
directory on your hard disk.
In Order to: Do This:
1. Load DOS into your computer Make sure hard disk is equipped
with DOS (version 2.0 or higher)
Turn on computer
2. Leave date and time unchanged Press [ENTER] twice
and bring up the "C>" prompt
3. Create a new directory for Type MD SAMPLE and press [ENTER]
Sampler file, called SAMPLE
4. Make SAMPLE the current directory Type CD SAMPLE and press [ENTER]
5. Copy files from Sampler Disk 1 Insert Sampler Disk 1 into drive
to the hard disk "A" by typing COPY A:*.* and
pressing [ENTER]
6. Copy files from Sampler Disk 2 Insert Sampler Disk 2 into drive
to the hard disk "A" by typing COPY A:*.* and
pressing [ENTER]
7. Start Framework II Sampler Type FWSAMPL and press [ENTER]
When prompted, press [ENTER]
After some disk whirring, the Framework II Sampler Menu appears on the
screen.
The Sampler Menu:
Automated Demonstration or Hands-on
The Framework II Sampler Menu
-----------------------------------------------------------------------
Framework II Sampler Menu
1. Automated Demonstration . . (a thru d)
a. Framework II Overview . . . 3 min
b. Word Processing . . . . . . 3 min
c. Spreadsheet . . . . . . . . 3 min
d. And More . . . . . . . . . 5 min
2. Hands-on . . . . . See Sampler Booklet
3. Quit the Sampler . . . . Return to DOS
To choose an option, press a number or a letter.
-----------------------------------------------------------------------
To choose an option from the Sampler Menu, press a number (using the
top row of number keys), or a letter.
You can go through the automated demonstration or hands-on exercises -
or both - in the order you choose.
Automated Demonstration
Choose option (1) to watch the entire automated demonstration, or press
a letter to just watch a particular section.
If you don't choose an option within about 60 seconds, option (a)
begins automatically. Once the demonstration is complete the Sampler
Menu is again presented.
The demonstration moves along at its own pace, much like a self-running
slide show. You can pause the demonstration at any time by pressing
the SPACEBAR. Or immediately advance to the next screen by pressing
[ENTER].
Press Esc to return to the Sampler Menu at any point during the
automated demonstration.
Hands On
Choose option (2) to get a direct experience of using Framework II.
Follow the step-by-step instructions on the following pages. The
exercises that follow are modular - you can go through one or all of
them in whatever order you choose.
Press Alt-S simultaneously to return to the Sampler Menu at any time
during a hands-on exercise.
Quick Orientation for Hands-on
Remember - you can't hurt the computer or Framework II by pressing the
wrong keys.
The following keys are used for special purposes by Framework II:
Key Function
F1 Help
F2 Edit Formula
F3 Drag
F4 Size
F5 Recalc
F6 Extend Select
F7 Move
F8 Copy
F9 Zoom
F10 View
Ins Instruct
Del Delete
ScrollLock Shuttle
Grey - Up Level
Grey + Down Level
Keys You Will Be Using
When you press keys on the keyboard, press and lift in one smooth
motion. Don't hold down a key unless specified by an instruction.
(Ordinarily, holding down a key is equivalent to pressing it a number
of times in a row.)
Locate - but don't press - the keys noted above on your keyboard.
Placement of certain keys may vary depending on your particular key-
board.
The Framework II Screen
Framework II transforms your computer screen into an "electronic
desktop."
Across the top of the screen is the menu bar - each menu name
represents a list of available commands. Across the bottom of the
screen is a highlighted status panel and two message lines which
display information about what you're working on.
The shaded area of the screen is the desktop, where you do your work.
Storage cabinets are shown in the upper-right corner - for example, an
<A:> symbol represents disk drive "A," where files can be stored on a
floppy disk.
Files that are currently on the desktop are represented by trays
stacked at the lower-right corner. Each tray represents an information
container called a frame, which you'll soon see can be "opened" on the
desktop and manipulated like an "electronic" sheet of paper.
Using Menus
Most of Framework II's commands are listed in "pull-down" menus. There
are two methods of getting to a menu, illustrated in the steps below.
The Scan-and-Choose method (for browsing through menus):
In Order To: Press:
1. Pull down a menu from the Ins (Instruct)
menu bar
2. Highlight the different Up or Down cursor keys repeat-
commands in a menu edly. Notice the one-line help
messages that appear for each
menu item at the bottom of the
screen
3. Scan the different pull- Left or Right cursor keys
down menus repeatedly. Notice the differ-
ent menu that appear
4. Leave the menus without Esc
choosing a command
Mistake? Don't worry if you make a mistake in the exercises that fol-
low. Look for a instructions like this for instructions on correcting
mistakes. In general, pressing Esc is a good way to get out of a jam.
The Fast-Track method (for direct access to a menu)
In Order to: Press:
1. Pull down the Create Menu Ctrl-C simultaneously (C=create)
2. Leave the menu without Esc
choosing a command
Choosing a command
You haven't actually executed a command yet, but there are two ways to
do so. Once inside a menu:
Highlight the command you want and press [ENTER], or
Press the first letter of the command you want to execute
You get experience with both methods in the exercises that follow.
Power of the Written Word - Word Processing
Congratulations - you have responsibility for a major new project.
A budget report you've been working on for the project is due within
the hour, and you need to make some revisions - fast.
Before you start, make sure you have the a list of special purpose keys
so you know which keys are which.
Opening a word frame
First you need to open the frame named Summary, now closed in its tray
at the corner of the desktop. It contains part of the report you've
been working on.
In Order to: Press:
1. Highlight the Summary tray Up or Down curser keys until the
Summary tray is highlighted
2. Open the Summary frame [ENTER]
Exploring the word frame
There's more text inside the Summary frame than you can see at the
moment. Follow the steps below to see more.
In Order to: Press:
1. Move the highlight into Grey + (Down Level)
the frame
2. See text beyond the bottom Down cursor repeatedly
edge of the frame
3. Zoom the frame up to full F9 (Zoom)
screen
4. Return to the upper-left Ctrl-Home simultaneously
corner of the frame
Adding a new sentence
You need to add a sentence about increased expenses.
In Order to: Press:
1. Move the cursor before the Down cursor four times
first word of the third End key
sentence Left cursor to the space before
the P in Performance
2. Add the new sentence Type the following sentence
(Don't press [ENTER], Framework
II will maintain the margins for
you):
Expenses for the first month
will be higher than we had
originally expected.
Mistake? If you make a typing mistake, press the Backspace key to
correct it.
Moving a sentence
Now you want to move the first sentence of the second paragraph so that
it comes right after the sentence you just type in.
In Order to: Press:
1. Highlight the sentence to Ctrl-Down cursor simultaneously
be moved - the first sentence (Do this twice)
of the second paragraph
2. Begin the move procedure F7 (Move)
3. Move the cursor to where Up cursor three times
sentence is to be moved
- make sure the cursor is
on the P in Performance
4. Finish the move procedure [ENTER]
Notice how the moved sentence
adjusts within the margins of
the paragraph
Adding emphasis
You want to be sure that the expected increase in expenses is noted in
your report, so you decide to boldface the sentence you typed in.
In Order to: Press:
1. Highlight the sentence you Ctrl-Up cursor simultaneously
typed in earlier
2. Pull down a menu from the Inc (Instruct)
menu bar
3. Move to the Words Menu Right cursor until Words Menu
opens
4. Choose the Bold command Up or Down cursor until Bold
command is highlighted then
[ENTER]
5. Return the highlight to a Esc
single cursor to better see
the boldfaced sentence
Centering text
Now you want to center the title at the top of the page.
In Order to: Press:
1. Move cursor to the "PROPOSED Up cursor until cursor is on the
BUDGET" title at top of frame first line
2. Choose the Center command from Ins (Instruct)
the Words Menu to center the Down cursor until Center command
title is highlighted, then [ENTER]
Running a spelling check
You're almost done, but you don't want to hand in a report with typing
or spelling mistakes. Framework II's spelling checker will make sure
you don't. (The Framework II Sampler has a limited dictionary compared
to the 80,000 word dictionary available in the actual program, but this
example should serve to illustrate the spelling check process.)
In Order to: Press:
1. Use the fast-track method of Ctrl-A simultaneously
choosing menu commands to open S for Spelling Check
the Spelling Check submenu
from the Apps (Applications)
Menu
2. Start the spelling check B for Begin Spelling Check
The disk whirs a moment as the
spelling check begins; Framework
II should find the misspelled
work "profitible" and then
display a number of options at
the bottom of the screen
Something wrong? If you made any typing mistakes in the sentence you
added, the spelling checker should find them. If any word other than
"profitible" is highlighted, just press G for Go On.
3. List suggested corrections for S for Suggest
the misspelled work "profit- After a moment, a number of sug-
ible," which should be high- gestions are presented at the
lighted in the last paragraph bottom of the screen
4. Choose the highlighted correct [ENTER]
spelling, "profitable," to Notice how the correct spelling
replace the misspelled word automatically replaces the mis-
spelled word
Closing the word frame
The spelling check is complete. Follow the steps below to close the
word frame.
In Order to: Press:
1. Zoom the frame back to its F9 (Zoom)
place on the desktop
2. Move the highlight up to Grey - (Up Level)
the frame border
3. Close the frame [ENTER]
The revisions are done
You wasted no time retyping
You boldfaced your main point for extra emphasis
Your spelling check insured against typing mistakes
Keeping your Number Straight - Spreadsheet
You've recently discovered that the estimated expenses for the project
you're working on are going to be higher than expected. You need to
update some numbers for the project's budget report.
Opening a spreadsheet frame
To update your spreadsheet numbers, you first need to open the Budget
frame, now closed in its tray at the corner of the desktop. You open
the spreadsheet frame the same way you open a word frame or any other
type of frame in Framework II.
In Order to: Press:
1. Highlight the Budget tray Up or Down cursor until Budget
tray is highlighted
2. Open the Budget frame [ENTER]
3. Zoom frame to full screen F9 (Zoom)
Exploring the spreadsheet
A spreadsheet is compose of columns and rows that intersect to form
cells, like an accountant's worksheet. Particular cell locations are
described by their column/row coordinates.
With Framework II, it's possible to have a spreadsheet with 32,000
columns and 32,000 rows. But you can only see part of the spreadsheet
at any one time because of the size of the screen. Follow the steps
below to see more of your spreadsheet.
In Order to: Press:
1. See columns beyond column Right cursor repeatedly
H at the right edge of the
screen
2. Return to column A Home key
3. Move sown spreadsheet beyond PgDn key repeatedly
row 20 a "screen full" at a
time
4. Move to lower-right corner Ctrl-End simultaneously
of the spreadsheet (32,000
columns and rows out!)
5. Return to cell A1 Ctrl-Home simultaneously
Checking out formulas
Some of the numbers you see are the calculated result of formulas in
the spreadsheet. You want to examine a few of the formulas that
produce the calculated results.
In Order to: Press:
1. Highlight cell B4 Right cursor once
Down cursor three times
2. See that the number in cell Look to the bottom of the screen
B4 is the calculated result at the left part of the high-
of adding numbers in cells lighted Status Panel and notice
B2 and B3 the formula B2 + B3
3. Highlight cell B3 to see if Up cursor
it has a formula 1275 entry in Status Panel indi-
cates that number was entered
from keyboard
4. Highlight cell C3 to see if Right cursor
it has a formula B3 * 1.14 formula in Status
Panel indicates that number in
cell C3 is 14% greater than
number in cell B3
Updating a number
The initial expenses for Jan are actual 1500, not 1275. You need to
update that number. All the formulas affected by the change will
recalculate automatically.
In Order to: Press:
1. Highlight cell B3 Left cursor
2. Change the number, and watch Use top row of numbers to type
how expenses for the remaining 1500 and then [ENTER]
months, and all totals, update
automatically
Mistake? If you notice a typing mistake after pressing [ENTER], just
repeat Step 2 and re-enter the correct number.
Formatting for currency
You're dealing with dollars here, so you want the spreadsheet numbers
to appear as currency.
In Order to: Press:
1. Select the first number Up cursor to highlight cell B2
to be formatted
2. Extend the selection to high- F6 (Extend Select)
light all the numbers to Down cursor twice
appear as currency, from cell Right cursor five times
B2 to cell G4
3. Finish the extended selection [ENTER]
Mistake? If you highlighted more or less than you want, just press Esc
twice and begin again.
In Order to: Press:
4. Choose the Currency command Ctrl-N simultaneously
from the Numbers Menu to C for Currency
format the number as dollars
5. Return the highlight to a Esc twice
single cell
6. Zoom spreadsheet back to its F9 (Zoom)
desktop frame
7. Move up to the frame border Grey - (Up Level)
and close the frame [ENTER]
Your spreadsheet budget is completely updated with the new projected
expenses. All you had to do was enter the expense figures for the
first month. Framework II did the rest.
And More . . . Getting the Big Picture - Graphics
You're almost ready to print out the budget report. You want to add a
graph to the report to clearly communicate an increase in estimated
expenses.
Selecting numbers to graph
You want to produce a graph of the Salaries and Expenses. First you
need to tell Framework II which numbers you want to graph.
In Order to: Press:
1. Open the Budget spreadsheet Up or Down cursor to highlight
frame Budget tray, if necessary, then
[ENTER]
2. Move the highlight into the Grey + (Down Level)
frame
3. Highlight the first number to Use the arrow keys to highlight
be graphed cell B2, if necessary
4. Extend the selection to high- F6 (Extend Select)
light just the numbers in the Down cursor once
Salaries and Expenses rows, Right cursor five times
from cell B2 to cell G3
5. Finish the extended selection [ENTER]
Mistake? If you highlighted more or less than you want, just press Esc
twice and begin again at Step 3.
Create a graph
Once the numbers you want to graph are selected, the rest is a snap.
In Order to: Press:
1. Choose Draw New Graph from the Ctrl-G simultaneously
Graph Menu to prepare to draw D for Draw New Graph
a graph
2. Draw a graph in an automatic- [ENTER]
ally created frame
3. Zoom graph to full screen F9 (Zoom)
4. Zoom graph back to its desktop F9 (Zoom)
frame
Giving the graph a name
The way you title a graph is to first label the graph frame the same
way you label any frame.
In Order to: Press
1. Label the graph frame Costs Type Costs, then [ENTER]
Typing Mistake? Press Esc and begin again.
2. Redraw the graph so the frame F5 (Recalc)
label appears as the graph
title
Positioning the graph frame
Sometimes frames on the desktop overlap other frames. If the graph
frame happens to have overlapped the spreadsheet numbers, and you want
to move the graph frame down a bit, follow the steps below. Otherwise,
skip ahead to Cleaning up the desktop.
In Order to:
1. Begin to reposition the graph F3 (Drag)
frame so you will be able to Down cursor until top edge of
see the numbers in the spread- "shadow frame" is below the
sheet spreadsheet numbers
2. Finish moving graph frame to [ENTER]
new destination
Cleaning up the desktop
Once you've examined the spreadsheet numbers and graph next to each
other, follow the step below to close both desktop frames at the same
time.
In Order to: Press:
1. Choose Clean Up Desktop Ctrl-D simultaneously
from the Disk Menu to close C for Clean Up Desktop
all open desktop frames
Good work - the graph you quickly created will add clarity and impact
to your report.
Putting it all Together - Outlining
So far you've worked with a word processing frame, a spreadsheet frame,
and a graph frame. A frame can also contain other frames, providing
complete flexibility in how you organize your work. For example, a
number of different frames containing words, numbers, and graphs can be
assembled together to print as one document.
Loading a file from a disk
The three frames you've worked with so far are already organized
together in a single frame stored as a file on your disk. Follow the
steps below to load the file called REPORT.FW2 to the desktop from the
disk containing the Sampler files.
In Order to: Press:
1. Highlight a closed disk- ScrollLock (Shuttle)
drive frame at the upper-
right corner of the desk-
top
2. Highlight the disk-drive Up or Down if necessary, to
frame representing the disk highlight <A:> or <C:>, which-
drive that contains the ever contains the disk with the
Framework II Sampler files Sampler files
3. Open the disk-drive frame to [ENTER]
see the directory of files
stored on the disk
4. Move the highlight into the Grey - (Down Level)
drive frame
5. Highlight the REPORT.FW2 Down cursor until REPORT.FW2 is
file highlighted
(Even if you don't see it at
first, keep pressing the down
cursor key)
Mistake? Inside wrong drive Press Grey - to get out.
6. Load the file to the desktop [ENTER]
Notice the highlight bar now on
the Report frame, closed in its
tray at the lower-right corner
of the desktop
Mistake? Load wrong file? Press Del to remove it from the desktop and
ScrollLock to shuttle back inside the drive frame.
Exploring a containing frame
The Report frame is now on the desktop. Follow the steps below to see
the three frames contained in the Report frame from several points of
view.
In Order to: Press:
1. Open the Report frame [ENTER]
Notice how the Report frame
overlaps the disk drive frame
2. Move the highlight into the Grey + (Down Level)
Report frame
3. Notice how the highlight bar Down cursor to Costs frame
appears on each of the three Up cursor to Summary frame
frames inside - when the
Report frame is in "Outline
View" only the frame labels
are displayed
4. Switch from "Outline view" to F10 (View)
"Contents view" to see what's
inside the frames
5. Move among the three frames Down cursor to Costs frame
while in "Contents view" to Up cursor to Summary frame
observe the order in which
the frames are organized for
printing
Closing desktop frames one by one
In Order to: Press:
1. Move up a level to the border Grey - (Up Level)
of the Report frame
2. Close the Report frame [ENTER]
3. Move over to the disk-drive ScrollLock (Shuttle)
frame and close it Grey - (Up Level)
[ENTER]
With Framework II you've completed your report in well under an hour.
And when you print the frame containing the three sections of your
report, a single printed page will include the text, spreadsheet, and
graph - a powerful summary of your project.
More about outlines
Containing frames, or outlines, are extremely powerful information
organizers.
Imagine the outline of a major report, with a separate frame for
each chapter or section, spreadsheets and graphs sprinkled through-
out.
In "Outline view," you not only can get an overview of your report
at a glance, but also rearrange your report simply by moving and
rearranging sections of the outline.
Outlines are a perfect tool for sketching out project tasks. You
can use outlines for brainstorming - to quickly capture and
organize your thoughts.
Outlines are flexible - you can easily add new sections, delete old
sections, and incorporate outside frames within an outline.
Framework II - Linking to dBASE III
You need to do a little survey for your new project. You have an ad-
dress list in a dBASE III database file stored on your disk, and want
to convert the list into a Framework II database so you can eventually
send out personalized letters using Framework II's MailMerge capabil-
ity.
Importing a dBASE III file
You can load a dBASE III file just as you load a Framework II file and
it will automatically convert into a Framework II database. Or you can
use the Import option in the Disk Menu. Follow the steps below to
import the dBASE III file called NAMES.DBF into Framework II.
In Order to: Press:
1. Open the Import submenu Ctrl-D simultaneously
from the Disk Menu I for Import
2. Specify the dBASE III file D for dBASE II/III
name and create a database Type names.dbf
frame to accept the dBASE [ENTER]
III information
Mistake? Unable to open file? Follow Steps 1 and 2 closely, and be
sure to type names.dbf exactly as it appears.
3. Extract the information from F5 (Recalc)
the dBASE III file to fill
empty Framework II database
frame
Sorting the database in alphabetical order
The database list is currently in no particular order. Follow the
steps below to sort the address list alphabetically by last name.
In Order to: Press:
1. Zoom the database frame to F9 (Zoom)
full screen
2. Choose Ascending Sort from Ctrl-L simultaneously
the Locate Menu to alpha- A for Ascending Sort
betize the list
Ready for MailMerge
Now that you have imported the dBASE III information into a Framework
II database frame, you'll be able to use Framework II's MailMerge
capability to send personalized form letters along with your survey.
Because the Framework II Sampler program does not include MailMerge,
however, you'll have to wait until you get the real Framework II. For
now, just close the database frame as described below.
In Order to: Press:
1. Zoom the database back to F9 (Zoom)
its desktop frame
2. Move up to the frame border Grey - (Up Level)
and close the frame [ENTER]
Congratulations! This completes the step-by-step exercises.
How to Quit the Framework II Sampler Program
When you are ready to quit the Framework II Sampler, the first thing
you need to do is return to the Framework II Sampler menu.
From the automated demonstration, press Esc
From the hands-on exercises, press Alt-S simultaneously
After the Framework II Sampler menu appears, choose option (3) to quit
the Framework II Sampler program and return to DOS.
If you have any questions or would like to see more of Framework II,
contact your local authorized Ashton-Tate dealer, or Ashton-Tate.
What you get with the new Framework II
The complete Framework II software package includes the following
materials and capabilities:
File saving capabilities
Printing capabilities for all major printers
Support of IBM Enhanced Graphics Adapter, and other major graphics
cards
Full telecommunications and terminal emulation capabilities
Ability to use memory beyond 540K: using extra RAM or hard disk
File "Import" and "Export" capabilities for using files from other
programs
80,000 word spelling checker dictionary
Complete set of program and tutorial disks
New set of manuals
New Setup program for customizing Framework II to your computer
system
Over 160 built-in, context-sensitive Help screens
Support from Ashton-Tate - one of the leading producers of computer
software
Framework II Sampler by Ashton-Tate
Framework II, the better solution for word processing, spreadsheets,
and more.
This package includes two diskettes containing the demonstration
program. The Framework II Sampler is a restricted version of the
actual Framework II software program.
Minimum System Requirements
The Framework II Sampler (and the actual Framework II program) require:
IBM PC,XT,AT,3270PC or 100% compatible (will not work on PCjr)
384K of internal memory (RAM)
Two 360K floppy-disk drives, or a single 360K floppy and hard-disk
drive
Monochrome or graphics monitor
PC DOS 2.0 or higher
Product Specifications
Word Processing
Complete text editing and format control
80,000 work Merriam-Webster spelling checker/corrector at no extra
charge*
Mail merge and label printing built-in*
Fully visible hard and soft page breaks with page number display
Outlining
Flexible "idea processor" and brainstorming tool
Organize words, numbers, and graphs within a single document
Streamline overview and editing of large documents
Automated Table of Contents creation
Arabic or conventional (Roman numeral) outline section numbering
Telecommunications*
Fully integrated menu-driven operation, with extensive on-line help
Access mainframes, mini- and micro-computers, and services such as
Dow Jones, CompuServe, and The Source
Background send or receive while performing other work
Terminal emulation of popular asynchronous terminals
Spreadsheet
Up to 32,000 rows by 32,000 columns
Significantly improved performance
Multiple spreadsheets available at one time, with complete linking
and consolidation capabilities
Over 160 built-in financial, mathematical, statistical, and Boolean
functions
New Goto command
Range printing*
Graphics
Bar, Stacked Bar, Line, Scatter, X-Y, Pie, and new High-Low-Close
graphs
Link graphs to spreadsheet or database for automatic updating when
numbers change
Graphs display on both monochrome and graphics monitors
Output graphs on dot matrix and letter-quality printers and
plotters*
Data Management
Read in and manipulate dBASE II and III files automatically
View data as a table, custom-designed form, or dBASE-style column
Sort 200 records in less than 2 seconds
Field defining formulas permit computed fields, error checking, and
data-entry validation
For the power user, there's FRED
FRED is a full-featured programming language that gives you access
to all the features and functions within Framework II for
creating customized applications
Supports libraries of user-defined functions
Over 100 specific diagnostic error messages
Approximate Capacities
Extended Memory*
Memory 348K 512K 640K 1Meg 2Meg
------ ---- ---- ---- ---- ----
WP Pages 40 100 150 300 700
SS Cells 2000 5000 8000 16000 32000
DB Records 250 600 1000 2000 3200
Assumptions:
Words per page: 400
Spreadsheet cell mix: 15% text, 25% numbers, 30% formulas, 30% empty
Database Records: 10 fields per record, 10 characters per field
Library Cabinet empty
* The functions noted above are included in the actual Framework II
program, but not in the Framework II Sampler.
The specifications list above is by no means complete. If you have any
questions, contact your local authorized Ashton-Tate dealer, or Ashton-
Tate.
Ashton-Tate, 20202 Hamilton Ave, Torrance, CA 90502-1319, (213)329-8000